package com.auxgroup.hr.front.dao.repository;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.auxgroup.hr.front.dao.domain.PsCHirePerTbl;

import java.math.BigDecimal;
import java.util.List;

/**
 * @author lv-PC
 *
 */
@Repository
public interface PsCHirePerTblRepository extends 
JpaRepository<PsCHirePerTbl,String>,JpaSpecificationExecutor<PsCHirePerTbl> {

    List<PsCHirePerTbl> findByNationalId(String nationalId);

//    @Query("SELECT MAX(rsHireId) FROM PsCHirePerTbl")
//    String getMaxHireId();
//
//    @Query("SELECT MAX(applicationId) FROM PsCHirePerTbl")
//    String getMaxApplicationId();
}